Pandas Profiling Report

Dataset statistics

Number of variables	36
Number of observations	135038
Missing cells	293365
Missing cells (%)	6.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.1 MiB
Average record size in memory	288.0 B

Variable types

Numeric	23
Categorical	13

Alerts

`Product_type` has constant value "FRM"	Constant
`Seller_Name` has a high cardinality: 94 distinct values	High cardinality
`Property_state` has a high cardinality: 54 distinct values	High cardinality
`Origination_Date` has a high cardinality: 234 distinct values	High cardinality
`First_payment_date` has a high cardinality: 235 distinct values	High cardinality
`Qdate` has a high cardinality: 78 distinct values	High cardinality
`Original_Interest_Rate` is highly correlated with `CPIAUCSL` and 4 other fields	High correlation
`Original_LTV_(OLTV)` is highly correlated with `Original_Combined_LTV_(CLTV)` and 1 other fields	High correlation
`Original_Combined_LTV_(CLTV)` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Borrower_Credit_Score_at_Origination` is highly correlated with `Co-borrower_credit_score_at_origination`	High correlation
`Primary_mortgage_insurance_percent` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Co-borrower_credit_score_at_origination` is highly correlated with `Borrower_Credit_Score_at_Origination`	High correlation
`UNRATE` is highly correlated with `DEXUSEU`	High correlation
`CPIAUCSL` is highly correlated with `Original_Interest_Rate` and 7 other fields	High correlation
`TCMR` is highly correlated with `Original_Interest_Rate` and 4 other fields	High correlation
`POILWTIUSDM` is highly correlated with `Original_Interest_Rate` and 7 other fields	High correlation
`TTLCONS` is highly correlated with `CPIAUCSL` and 2 other fields	High correlation
`DEXUSEU` is highly correlated with `UNRATE` and 3 other fields	High correlation
`BOPGSTB` is highly correlated with `POILWTIUSDM` and 2 other fields	High correlation
`GOLDAMGBD228NLBM` is highly correlated with `Original_Interest_Rate` and 6 other fields	High correlation
`CSUSHPISA` is highly correlated with `CPIAUCSL` and 5 other fields	High correlation
`MSPUS` is highly correlated with `Original_Interest_Rate` and 7 other fields	High correlation
`Original_Interest_Rate` is highly correlated with `CPIAUCSL` and 4 other fields	High correlation
`Original_LTV_(OLTV)` is highly correlated with `Original_Combined_LTV_(CLTV)` and 1 other fields	High correlation
`Original_Combined_LTV_(CLTV)` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Borrower_Credit_Score_at_Origination` is highly correlated with `Co-borrower_credit_score_at_origination`	High correlation
`Primary_mortgage_insurance_percent` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Co-borrower_credit_score_at_origination` is highly correlated with `Borrower_Credit_Score_at_Origination`	High correlation
`UNRATE` is highly correlated with `TTLCONS` and 1 other fields	High correlation
`CPIAUCSL` is highly correlated with `Original_Interest_Rate` and 7 other fields	High correlation
`TCMR` is highly correlated with `Original_Interest_Rate` and 5 other fields	High correlation
`POILWTIUSDM` is highly correlated with `CPIAUCSL` and 3 other fields	High correlation
`TTLCONS` is highly correlated with `UNRATE` and 4 other fields	High correlation
`DEXUSEU` is highly correlated with `UNRATE` and 4 other fields	High correlation
`BOPGSTB` is highly correlated with `TTLCONS` and 2 other fields	High correlation
`GOLDAMGBD228NLBM` is highly correlated with `Original_Interest_Rate` and 6 other fields	High correlation
`CSUSHPISA` is highly correlated with `Original_Interest_Rate` and 6 other fields	High correlation
`MSPUS` is highly correlated with `Original_Interest_Rate` and 5 other fields	High correlation
`Original_Interest_Rate` is highly correlated with `CPIAUCSL` and 3 other fields	High correlation
`Original_LTV_(OLTV)` is highly correlated with `Original_Combined_LTV_(CLTV)` and 1 other fields	High correlation
`Original_Combined_LTV_(CLTV)` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Borrower_Credit_Score_at_Origination` is highly correlated with `Co-borrower_credit_score_at_origination`	High correlation
`Primary_mortgage_insurance_percent` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Co-borrower_credit_score_at_origination` is highly correlated with `Borrower_Credit_Score_at_Origination`	High correlation
`CPIAUCSL` is highly correlated with `Original_Interest_Rate` and 5 other fields	High correlation
`TCMR` is highly correlated with `Original_Interest_Rate` and 3 other fields	High correlation
`POILWTIUSDM` is highly correlated with `CPIAUCSL` and 2 other fields	High correlation
`TTLCONS` is highly correlated with `CSUSHPISA` and 1 other fields	High correlation
`DEXUSEU` is highly correlated with `POILWTIUSDM` and 1 other fields	High correlation
`GOLDAMGBD228NLBM` is highly correlated with `Original_Interest_Rate` and 5 other fields	High correlation
`CSUSHPISA` is highly correlated with `CPIAUCSL` and 2 other fields	High correlation
`MSPUS` is highly correlated with `Original_Interest_Rate` and 5 other fields	High correlation
`Product_type` is highly correlated with `Property_state` and 9 other fields	High correlation
`Property_state` is highly correlated with `Product_type`	High correlation
`Qdate` is highly correlated with `Product_type`	High correlation
`Origination_Channel` is highly correlated with `Product_type`	High correlation
`Number_of_units` is highly correlated with `Product_type`	High correlation
`Property_type` is highly correlated with `Product_type`	High correlation
`Seller_Name` is highly correlated with `Product_type`	High correlation
`Loan_purpose` is highly correlated with `Product_type`	High correlation
`Occupancy_type` is highly correlated with `Product_type`	High correlation
`First_time_home_buyer_indicator` is highly correlated with `Product_type`	High correlation
`Mortgage_Insurance_type` is highly correlated with `Product_type`	High correlation
`Origination_Channel` is highly correlated with `Seller_Name`	High correlation
`Seller_Name` is highly correlated with `Origination_Channel` and 11 other fields	High correlation
`Original_Interest_Rate` is highly correlated with `Seller_Name` and 11 other fields	High correlation
`Original_Loan_Term` is highly correlated with `Primary_mortgage_insurance_percent`	High correlation
`Original_LTV_(OLTV)` is highly correlated with `Original_Combined_LTV_(CLTV)` and 1 other fields	High correlation
`Original_Combined_LTV_(CLTV)` is highly correlated with `Original_LTV_(OLTV)` and 1 other fields	High correlation
`Borrower_Credit_Score_at_Origination` is highly correlated with `Co-borrower_credit_score_at_origination`	High correlation
`Property_state` is highly correlated with `Zip_code_short`	High correlation
`Zip_code_short` is highly correlated with `Property_state`	High correlation
`Primary_mortgage_insurance_percent` is highly correlated with `Original_Loan_Term` and 2 other fields	High correlation
`Co-borrower_credit_score_at_origination` is highly correlated with `Borrower_Credit_Score_at_Origination`	High correlation
`UNRATE` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`CPIAUCSL` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`Qdate` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`rGDP` is highly correlated with `UNRATE` and 10 other fields	High correlation
`TCMR` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`POILWTIUSDM` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`TTLCONS` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`DEXUSEU` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`BOPGSTB` is highly correlated with `Original_Interest_Rate` and 11 other fields	High correlation
`GOLDAMGBD228NLBM` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`CSUSHPISA` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`MSPUS` is highly correlated with `Seller_Name` and 12 other fields	High correlation
`Original_Debt_to_Income_Ratio` has 2642 (2.0%) missing values	Missing
`Primary_mortgage_insurance_percent` has 110716 (82.0%) missing values	Missing
`Co-borrower_credit_score_at_origination` has 67672 (50.1%) missing values	Missing
`Mortgage_Insurance_type` has 110716 (82.0%) missing values	Missing

Reproduction

Analysis started	2022-04-06 17:47:01.696627
Analysis finished	2022-04-06 17:49:02.034217
Duration	2 minutes and 0.34 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Loan_Identifier
Real number (ℝ_≥0)

Distinct	125363
Distinct (%)	92.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.518022819 × 10¹¹

Minimum	1.00002 × 10¹¹
Maximum	9.99985 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1.00002 × 10¹¹
5-th percentile	1.4584125 × 10¹¹
Q1	3.270665 × 10¹¹
median	5.525325 × 10¹¹
Q3	7.7732825 × 10¹¹
95-th percentile	9.561356 × 10¹¹
Maximum	9.99985 × 10¹¹
Range	8.99983 × 10¹¹
Interquartile range (IQR)	4.5026175 × 10¹¹

Descriptive statistics

Standard deviation	2.597821488 × 10¹¹
Coefficient of variation (CV)	0.4707884642
Kurtosis	-1.201513582
Mean	5.518022819 × 10¹¹
Median Absolute Deviation (MAD)	2.251105 × 10¹¹
Skewness	-0.008013935302
Sum	7.451427654 × 10¹⁶
Variance	6.748676485 × 10²²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.9732 × 10¹¹	4	< 0.1%
2.59153 × 10¹¹	4	< 0.1%
7.57067 × 10¹¹	4	< 0.1%
7.50054 × 10¹¹	4	< 0.1%
4.3854 × 10¹¹	4	< 0.1%
6.65386 × 10¹¹	4	< 0.1%
1.38101 × 10¹¹	4	< 0.1%
5.37573 × 10¹¹	4	< 0.1%
9.98433 × 10¹¹	4	< 0.1%
3.31339 × 10¹¹	4	< 0.1%
Other values (125353)	134998	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.00002 × 10¹¹	1	< 0.1%
1.00032 × 10¹¹	1	< 0.1%
1.00035 × 10¹¹	1	< 0.1%
1.00041 × 10¹¹	1	< 0.1%
1.00046 × 10¹¹	1	< 0.1%
1.00049 × 10¹¹	1	< 0.1%
1.00051 × 10¹¹	1	< 0.1%
1.00061 × 10¹¹	1	< 0.1%
1.00069 × 10¹¹	1	< 0.1%
1.00072 × 10¹¹	3	< 0.1%

Value	Count	Frequency (%)
9.99985 × 10¹¹	1	< 0.1%
9.99972 × 10¹¹	1	< 0.1%
9.9997 × 10¹¹	1	< 0.1%
9.99965 × 10¹¹	1	< 0.1%
9.99951 × 10¹¹	1	< 0.1%
9.9995 × 10¹¹	1	< 0.1%
9.99949 × 10¹¹	1	< 0.1%
9.99947 × 10¹¹	1	< 0.1%
9.99934 × 10¹¹	1	< 0.1%
9.99919 × 10¹¹	1	< 0.1%

Origination_Channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

R	67857
C	46756
B	20425

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	B
3rd row	B
4th row	C
5th row	R

Common Values

Value	Count	Frequency (%)
R	67857	50.3%
C	46756	34.6%
B	20425	15.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
r	67857	50.3%
c	46756	34.6%
b	20425	15.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Seller_Name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	94
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

OTHER	46014
BANK OF AMERICA, N.A.	15626
WELLS FARGO BANK, N.A.	14838
JPMORGAN CHASE BANK, NA	9712
JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	7836
Other values (89)	41012

Length

Max length	68
Median length	18
Mean length	17.40043543
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	OTHER
2nd row	PNC BANK, N.A.
3rd row	OTHER
4th row	AMTRUST BANK
5th row	OTHER

Common Values

Value	Count	Frequency (%)
OTHER	46014	34.1%
BANK OF AMERICA, N.A.	15626	11.6%
WELLS FARGO BANK, N.A.	14838	11.0%
JPMORGAN CHASE BANK, NA	9712	7.2%
JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	7836	5.8%
CITIMORTGAGE, INC.	5950	4.4%
GMAC MORTGAGE, LLC	4278	3.2%
FLAGSTAR BANK, FSB	3308	2.4%
SUNTRUST MORTGAGE INC.	3059	2.3%
QUICKEN LOANS INC.	3007	2.2%
Other values (84)	21410	15.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bank	59587	15.9%
other	46014	12.3%
n.a	31896	8.5%
chase	17971	4.8%
jpmorgan	17548	4.7%
of	15977	4.3%
america	15724	4.2%
wells	14881	4.0%
fargo	14881	4.0%
mortgage	14179	3.8%
Other values (139)	126427	33.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Original_Interest_Rate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	885
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.238376478

Minimum	2.25
Maximum	11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	2.25
5-th percentile	3.309849915
Q1	4.25
median	5.25
Q3	6.125
95-th percentile	7.375
Maximum	11
Range	8.75
Interquartile range (IQR)	1.875

Descriptive statistics

Standard deviation	1.28989546
Coefficient of variation (CV)	0.2462395488
Kurtosis	-0.5204123179
Mean	5.238376478
Median Absolute Deviation (MAD)	1
Skewness	0.2567090033
Sum	707379.8828
Variance	1.663830299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.875	6754	5.0%
4.875	5729	4.2%
4.375	4937	3.7%
4.25	4926	3.6%
5.75	4820	3.6%
3.875	4620	3.4%
4.5	4383	3.2%
6	4368	3.2%
6.25	4174	3.1%
5.375	4146	3.1%
Other values (875)	86181	63.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.25	4	< 0.1%
2.375	17	< 0.1%
2.45	1	< 0.1%
2.5	143	0.1%
2.54	1	< 0.1%
2.55	2	< 0.1%
2.5999999	3	< 0.1%
2.625	270	0.2%
2.6500001	1	< 0.1%
2.6600001	1	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
10.25	2	< 0.1%
10.125	1	< 0.1%
10	1	< 0.1%
9.875	1	< 0.1%
9.75	4	< 0.1%
9.625	9	< 0.1%
9.5	17	< 0.1%
9.375	13	< 0.1%
9.3249998	1	< 0.1%

Original_UPB
Real number (ℝ_≥0)

Distinct	717
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	188931.0713

Minimum	8000
Maximum	1170000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	8000
5-th percentile	59000
Q1	108000
median	164000
Q3	247000
95-th percentile	405000
Maximum	1170000
Range	1162000
Interquartile range (IQR)	139000

Descriptive statistics

Standard deviation	108742.3794
Coefficient of variation (CV)	0.5755664151
Kurtosis	2.089248292
Mean	188931.0713
Median Absolute Deviation (MAD)	64000
Skewness	1.241016237
Sum	2.5512874 × 10¹⁰
Variance	1.182490507 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
417000	1986	1.5%
100000	1972	1.5%
200000	1714	1.3%
150000	1514	1.1%
120000	1263	0.9%
160000	1153	0.9%
140000	1108	0.8%
180000	1068	0.8%
90000	1064	0.8%
80000	1045	0.8%
Other values (707)	121151	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8000	1	< 0.1%
10000	2	< 0.1%
11000	5	< 0.1%
13000	3	< 0.1%
14000	4	< 0.1%
15000	8	< 0.1%
16000	5	< 0.1%
17000	5	< 0.1%
18000	8	< 0.1%
19000	8	< 0.1%

Value	Count	Frequency (%)
1170000	1	< 0.1%
1121000	1	< 0.1%
1000000	1	< 0.1%
985000	1	< 0.1%
938000	1	< 0.1%
927000	1	< 0.1%
870000	1	< 0.1%
815000	2	< 0.1%
813000	1	< 0.1%
805000	1	< 0.1%

Original_Loan_Term
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	127
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	307.0648262

Minimum	60
Maximum	360
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	60
5-th percentile	180
Q1	240
median	360
Q3	360
95-th percentile	360
Maximum	360
Range	300
Interquartile range (IQR)	120

Descriptive statistics

Standard deviation	82.33167429
Coefficient of variation (CV)	0.2681247322
Kurtosis	-0.7829963816
Mean	307.0648262
Median Absolute Deviation (MAD)	0
Skewness	-1.011882662
Sum	41465420
Variance	6778.504591
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
360	93557	69.3%
180	29335	21.7%
240	6223	4.6%
120	3993	3.0%
300	986	0.7%
144	72	0.1%
96	59	< 0.1%
156	56	< 0.1%
348	49	< 0.1%
168	49	< 0.1%
Other values (117)	659	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
60	4	< 0.1%
72	2	< 0.1%
78	1	< 0.1%
84	8	< 0.1%
96	59	< 0.1%
100	1	< 0.1%
103	1	< 0.1%
106	1	< 0.1%
108	19	< 0.1%
109	1	< 0.1%

Value	Count	Frequency (%)
360	93557	69.3%
359	4	< 0.1%
358	4	< 0.1%
357	5	< 0.1%
356	12	< 0.1%
355	15	< 0.1%
354	27	< 0.1%
353	29	< 0.1%
352	21	< 0.1%
351	23	< 0.1%

Original_LTV_(OLTV)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	94
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.05729498

Minimum	4
Maximum	97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	4
5-th percentile	35
Q1	60
median	75
Q3	80
95-th percentile	95
Maximum	97
Range	93
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	17.4931782
Coefficient of variation (CV)	0.2496981679
Kurtosis	0.2871075184
Mean	70.05729498
Median Absolute Deviation (MAD)	9
Skewness	-0.8332872297
Sum	9460397
Variance	306.0112836
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80	27633	20.5%
95	8194	6.1%
75	6801	5.0%
90	6241	4.6%
70	3848	2.8%
79	3484	2.6%
78	2864	2.1%
74	2689	2.0%
73	2525	1.9%
77	2379	1.8%
Other values (84)	68380	50.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
5	4	< 0.1%
6	5	< 0.1%
7	15	< 0.1%
8	12	< 0.1%
9	22	< 0.1%
10	32	< 0.1%
11	41	< 0.1%
12	52	< 0.1%
13	65	< 0.1%

Value	Count	Frequency (%)
97	1961	1.5%
96	62	< 0.1%
95	8194	6.1%
94	613	0.5%
93	533	0.4%
92	486	0.4%
91	248	0.2%
90	6241	4.6%
89	895	0.7%
88	749	0.6%

Original_Combined_LTV_(CLTV)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	110
Distinct (%)	0.1%
Missing	1031
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	70.86085801

Minimum	4
Maximum	142
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	4
5-th percentile	36
Q1	61
median	75
Q3	80
95-th percentile	95
Maximum	142
Range	138
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	17.56660673
Coefficient of variation (CV)	0.2479028228
Kurtosis	0.3041430708
Mean	70.86085801
Median Absolute Deviation (MAD)	10
Skewness	-0.8334307875
Sum	9495851
Variance	308.585672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80	25239	18.7%
95	9030	6.7%
90	7567	5.6%
75	6649	4.9%
70	3760	2.8%
79	3361	2.5%
78	2776	2.1%
74	2640	2.0%
73	2466	1.8%
77	2294	1.7%
Other values (100)	68225	50.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
5	3	< 0.1%
6	5	< 0.1%
7	14	< 0.1%
8	12	< 0.1%
9	21	< 0.1%
10	28	< 0.1%
11	36	< 0.1%
12	47	< 0.1%
13	58	< 0.1%

Value	Count	Frequency (%)
142	1	< 0.1%
137	1	< 0.1%
128	1	< 0.1%
124	1	< 0.1%
111	1	< 0.1%
110	1	< 0.1%
108	1	< 0.1%
106	1	< 0.1%
105	38	< 0.1%
104	29	< 0.1%

Number_of_Borrowers
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	31
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.587910257

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	2
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5084095479
Coefficient of variation (CV)	0.3201752403
Kurtosis	-0.5113864406
Mean	1.587910257
Median Absolute Deviation (MAD)	0
Skewness	-0.06751714976
Sum	214379
Variance	0.2584802684
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	77876	57.7%
1	56485	41.8%
3	466	0.3%
4	166	0.1%
5	8	< 0.1%
6	4	< 0.1%
8	2	< 0.1%
(Missing)	31	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	56485	41.8%
2	77876	57.7%
3	466	0.3%
4	166	0.1%
5	8	< 0.1%
6	4	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
8	2	< 0.1%
6	4	< 0.1%
5	8	< 0.1%
4	166	0.1%
3	466	0.3%
2	77876	57.7%
1	56485	41.8%

Original_Debt_to_Income_Ratio
Real number (ℝ_≥0)

MISSING

Distinct	64
Distinct (%)	< 0.1%
Missing	2642
Missing (%)	2.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.29873259

Minimum	1
Maximum	64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	15
Q1	25
median	33
Q3	42
95-th percentile	52
Maximum	64
Range	63
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.50869764
Coefficient of variation (CV)	0.3456196902
Kurtosis	-0.3792129474
Mean	33.29873259
Median Absolute Deviation (MAD)	8
Skewness	0.08045905992
Sum	4408619
Variance	132.4501214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	4168	3.1%
34	4121	3.1%
38	4098	3.0%
39	4096	3.0%
36	4082	3.0%
41	4067	3.0%
42	4049	3.0%
37	4046	3.0%
31	4017	3.0%
40	4008	3.0%
Other values (54)	91644	67.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11	< 0.1%
2	42	< 0.1%
3	50	< 0.1%
4	73	0.1%
5	111	0.1%
6	181	0.1%
7	238	0.2%
8	354	0.3%
9	445	0.3%
10	635	0.5%

Value	Count	Frequency (%)
64	359	0.3%
63	368	0.3%
62	342	0.3%
61	423	0.3%
60	448	0.3%
59	490	0.4%
58	514	0.4%
57	543	0.4%
56	696	0.5%
55	741	0.5%

Borrower_Credit_Score_at_Origination
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	347
Distinct (%)	0.3%
Missing	557
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	742.4287966

Minimum	361
Maximum	850
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	361
5-th percentile	641
Q1	707
median	755
Q3	786
95-th percentile	808
Maximum	850
Range	489
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	53.42807552
Coefficient of variation (CV)	0.07196390517
Kurtosis	0.2222909648
Mean	742.4287966
Median Absolute Deviation (MAD)	36
Skewness	-0.8345198247
Sum	99842567
Variance	2854.559254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
791	1474	1.1%
801	1468	1.1%
784	1388	1.0%
797	1381	1.0%
802	1358	1.0%
790	1357	1.0%
786	1312	1.0%
798	1300	1.0%
788	1296	1.0%
782	1288	1.0%
Other values (337)	120859	89.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
361	1	< 0.1%
400	1	< 0.1%
444	7	< 0.1%
467	1	< 0.1%
476	1	< 0.1%
480	1	< 0.1%
488	1	< 0.1%
493	2	< 0.1%
494	1	< 0.1%
496	3	< 0.1%

Value	Count	Frequency (%)
850	3	< 0.1%
843	1	< 0.1%
838	2	< 0.1%
837	2	< 0.1%
835	2	< 0.1%
833	2	< 0.1%
832	12	< 0.1%
831	2	< 0.1%
830	2	< 0.1%
829	18	< 0.1%

Loan_purpose
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

P	47900
R	46740
C	40348
U	50

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P
2nd row	P
3rd row	C
4th row	C
5th row	C

Common Values

Value	Count	Frequency (%)
P	47900	35.5%
R	46740	34.6%
C	40348	29.9%
U	50	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
p	47900	35.5%
r	46740	34.6%
c	40348	29.9%
u	50	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Property_type
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

SF	99740
PU	23060
CO	10701
MH	864
CP	673

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SF
2nd row	SF
3rd row	SF
4th row	SF
5th row	SF

Common Values

Value	Count	Frequency (%)
SF	99740	73.9%
PU	23060	17.1%
CO	10701	7.9%
MH	864	0.6%
CP	673	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
sf	99740	73.9%
pu	23060	17.1%
co	10701	7.9%
mh	864	0.6%
cp	673	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Number_of_units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

1.0	131633
2.0	2504
3.0	477
4.0	424

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	131633	97.5%
2.0	2504	1.9%
3.0	477	0.4%
4.0	424	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	131633	97.5%
2.0	2504	1.9%
3.0	477	0.4%
4.0	424	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Occupancy_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

P	120399
I	9238
S	5401

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P
2nd row	P
3rd row	P
4th row	I
5th row	P

Common Values

Value	Count	Frequency (%)
P	120399	89.2%
I	9238	6.8%
S	5401	4.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
p	120399	89.2%
i	9238	6.8%
s	5401	4.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Property_state
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	54
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

CA	20316
TX	7990
FL	7327
IL	6468
MI	4909
Other values (49)	88028

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AL
2nd row	AL
3rd row	AL
4th row	AL
5th row	AR

Common Values

Value	Count	Frequency (%)
CA	20316	15.0%
TX	7990	5.9%
FL	7327	5.4%
IL	6468	4.8%
MI	4909	3.6%
NY	4886	3.6%
WA	4293	3.2%
PA	4291	3.2%
MA	4257	3.2%
NJ	3982	2.9%
Other values (44)	66319	49.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	20316	15.0%
tx	7990	5.9%
fl	7327	5.4%
il	6468	4.8%
mi	4909	3.6%
ny	4886	3.6%
wa	4293	3.2%
pa	4291	3.2%
ma	4257	3.2%
nj	3982	2.9%
Other values (44)	66319	49.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Zip_code_short
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	892
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	545.9760956

Minimum	0
Maximum	999
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	56
Q1	295
median	549
Q3	844
95-th percentile	970
Maximum	999
Range	999
Interquartile range (IQR)	549

Descriptive statistics

Standard deviation	306.0106241
Coefficient of variation (CV)	0.560483557
Kurtosis	-1.301477705
Mean	545.9760956
Median Absolute Deviation (MAD)	268
Skewness	-0.1170295055
Sum	73727520
Variance	93642.50206
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
945	1772	1.3%
300	1194	0.9%
600	1159	0.9%
750	1148	0.9%
926	1135	0.8%
852	1099	0.8%
980	1090	0.8%
917	1070	0.8%
606	958	0.7%
481	957	0.7%
Other values (882)	123456	91.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
6	95	0.1%
7	117	0.1%
8	15	< 0.1%
9	165	0.1%
10	152	0.1%
11	47	< 0.1%
12	54	< 0.1%
13	21	< 0.1%
14	124	0.1%

Value	Count	Frequency (%)
999	4	< 0.1%
998	23	< 0.1%
997	35	< 0.1%
996	69	0.1%
995	139	0.1%
994	10	< 0.1%
993	165	0.1%
992	188	0.1%
991	41	< 0.1%
990	89	0.1%

Primary_mortgage_insurance_percent
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	20
Distinct (%)	0.1%
Missing	110716
Missing (%)	82.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.75980594

Minimum	6
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	6
5-th percentile	12
Q1	18
median	25
Q3	30
95-th percentile	30
Maximum	50
Range	44
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.15112836
Coefficient of variation (CV)	0.3009758741
Kurtosis	-0.3705245698
Mean	23.75980594
Median Absolute Deviation (MAD)	5
Skewness	-0.7907650624
Sum	577886
Variance	51.13863683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
25	9396	7.0%
30	7489	5.5%
12	3806	2.8%
17	1334	1.0%
35	953	0.7%
6	625	0.5%
18	474	0.4%
16	210	0.2%
20	10	< 0.1%
40	7	< 0.1%
Other values (10)	18	< 0.1%
(Missing)	110716	82.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	625	0.5%
10	1	< 0.1%
12	3806	2.8%
15	4	< 0.1%
16	210	0.2%
17	1334	1.0%
18	474	0.4%
20	10	< 0.1%
22	1	< 0.1%
23	1	< 0.1%

Value	Count	Frequency (%)
50	2	< 0.1%
40	7	< 0.1%
39	1	< 0.1%
38	1	< 0.1%
35	953	0.7%
33	1	< 0.1%
30	7489	5.5%
28	2	< 0.1%
27	4	< 0.1%
25	9396	7.0%

Product_type
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

FRM	135038

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FRM
2nd row	FRM
3rd row	FRM
4th row	FRM
5th row	FRM

Common Values

Value	Count	Frequency (%)
FRM	135038	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
frm	135038	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Co-borrower_credit_score_at_origination
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	327
Distinct (%)	0.5%
Missing	67672
Missing (%)	50.1%
Infinite	0
Infinite (%)	0.0%
Mean	751.1459045

Minimum	400
Maximum	850
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	400
5-th percentile	651
Q1	721
median	765
Q3	791
95-th percentile	810
Maximum	850
Range	450
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	50.57622641
Coefficient of variation (CV)	0.06733209369
Kurtosis	0.6414205765
Mean	751.1459045
Median Absolute Deviation (MAD)	31
Skewness	-1.005586451
Sum	50601695
Variance	2557.954678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
801	878	0.7%
791	870	0.6%
790	837	0.6%
798	805	0.6%
796	798	0.6%
793	798	0.6%
797	789	0.6%
784	778	0.6%
802	771	0.6%
809	755	0.6%
Other values (317)	59287	43.9%
(Missing)	67672	50.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
400	1	< 0.1%
467	1	< 0.1%
471	1	< 0.1%
484	1	< 0.1%
486	1	< 0.1%
487	1	< 0.1%
498	1	< 0.1%
501	1	< 0.1%
505	2	< 0.1%
512	2	< 0.1%

Value	Count	Frequency (%)
850	1	< 0.1%
839	2	< 0.1%
838	2	< 0.1%
835	1	< 0.1%
834	2	< 0.1%
833	1	< 0.1%
832	3	< 0.1%
831	1	< 0.1%
830	3	< 0.1%
829	9	< 0.1%

Mortgage_Insurance_type
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	110716
Missing (%)	82.0%
Memory size	1.0 MiB

1.0	22332
2.0	1988
3.0	2

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	22332	16.5%
2.0	1988	1.5%
3.0	2	< 0.1%
(Missing)	110716	82.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	22332	91.8%
2.0	1988	8.2%
3.0	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Origination_Date
Categorical

HIGH CARDINALITY

Distinct	234
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

2003-07-01	2163
2003-04-01	2128
2003-06-01	1985
2003-05-01	1840
2002-12-01	1775
Other values (229)	125147

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2007-02-01
2nd row	2007-02-01
3rd row	2007-02-01
4th row	2007-02-01
5th row	2007-02-01

Common Values

Value	Count	Frequency (%)
2003-07-01	2163	1.6%
2003-04-01	2128	1.6%
2003-06-01	1985	1.5%
2003-05-01	1840	1.4%
2002-12-01	1775	1.3%
2002-10-01	1770	1.3%
2003-03-01	1727	1.3%
2002-11-01	1637	1.2%
2003-08-01	1629	1.2%
2003-01-01	1545	1.1%
Other values (224)	116839	86.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2003-07-01	2163	1.6%
2003-04-01	2128	1.6%
2003-06-01	1985	1.5%
2003-05-01	1840	1.4%
2002-12-01	1775	1.3%
2002-10-01	1770	1.3%
2003-03-01	1727	1.3%
2002-11-01	1637	1.2%
2003-08-01	1629	1.2%
2003-01-01	1545	1.1%
Other values (224)	116839	86.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

First_payment_date
Categorical

HIGH CARDINALITY

Distinct	235
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

2003-09-01	2144
2003-06-01	2109
2003-08-01	1993
2003-07-01	1851
2003-05-01	1785
Other values (230)	125156

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2007-03-01
2nd row	2007-04-01
3rd row	2007-04-01
4th row	2007-04-01
5th row	2007-04-01

Common Values

Value	Count	Frequency (%)
2003-09-01	2144	1.6%
2003-06-01	2109	1.6%
2003-08-01	1993	1.5%
2003-07-01	1851	1.4%
2003-05-01	1785	1.3%
2002-12-01	1740	1.3%
2003-02-01	1735	1.3%
2003-01-01	1649	1.2%
2003-10-01	1595	1.2%
2003-03-01	1550	1.1%
Other values (225)	116887	86.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2003-09-01	2144	1.6%
2003-06-01	2109	1.6%
2003-08-01	1993	1.5%
2003-07-01	1851	1.4%
2003-05-01	1785	1.3%
2002-12-01	1740	1.3%
2003-02-01	1735	1.3%
2003-01-01	1649	1.2%
2003-10-01	1595	1.2%
2003-03-01	1550	1.1%
Other values (225)	116887	86.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

First_time_home_buyer_indicator
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

N	120561
Y	14409
U	68

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Y
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	120561	89.3%
Y	14409	10.7%
U	68	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
n	120561	89.3%
y	14409	10.7%
u	68	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

UNRATE
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	55
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.158662006

Minimum	3.8
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	3.8
5-th percentile	4.1
Q1	4.9
median	5.7
Q3	7.5
95-th percentile	9.5
Maximum	10
Range	6.2
Interquartile range (IQR)	2.6

Descriptive statistics

Standard deviation	1.657191534
Coefficient of variation (CV)	0.2690830464
Kurtosis	-0.4580471642
Mean	6.158662006
Median Absolute Deviation (MAD)	0.9
Skewness	0.7974035707
Sum	831653.4
Variance	2.746283782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.7	9928	7.4%
5	8106	6.0%
6.1	6034	4.5%
5.9	5976	4.4%
5.8	5757	4.3%
4.9	5389	4.0%
4.7	4805	3.6%
6	4702	3.5%
4.4	4485	3.3%
5.6	3884	2.9%
Other values (45)	75972	56.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.8	634	0.5%
3.9	1712	1.3%
4	2930	2.2%
4.1	2837	2.1%
4.2	2392	1.8%
4.3	3223	2.4%
4.4	4485	3.3%
4.5	2153	1.6%
4.6	2821	2.1%
4.7	4805	3.6%

Value	Count	Frequency (%)
10	444	0.3%
9.9	1743	1.3%
9.8	1818	1.3%
9.6	780	0.6%
9.5	2914	2.2%
9.4	2724	2.0%
9.3	723	0.5%
9.1	1108	0.8%
9	3408	2.5%
8.8	712	0.5%

CPIAUCSL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	223
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	208.1883261

Minimum	164.7
Maximum	251.176
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	164.7
5-th percentile	176.1
Q1	183.1
median	212.495
Q3	231.797
95-th percentile	244.028
Maximum	251.176
Range	86.476
Interquartile range (IQR)	48.697

Descriptive statistics

Standard deviation	24.77699426
Coefficient of variation (CV)	0.1190124092
Kurtosis	-1.534392425
Mean	208.1883261
Median Absolute Deviation (MAD)	25.095
Skewness	0.03714129161
Sum	28113335.18
Variance	613.8994448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
177.4	2905	2.2%
183.7	2163	1.6%
183.2	2128	1.6%
183.1	1985	1.5%
177.7	1905	1.4%
182.9	1840	1.4%
181.8	1775	1.3%
181.2	1770	1.3%
183.9	1727	1.3%
181.5	1637	1.2%
Other values (213)	115203	85.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
164.7	20	< 0.1%
164.8	6	< 0.1%
165.9	6	< 0.1%
166	18	< 0.1%
166.7	7	< 0.1%
167.1	12	< 0.1%
167.8	14	< 0.1%
168.1	27	< 0.1%
168.4	135	0.1%
168.8	292	0.2%

Value	Count	Frequency (%)
251.176	118	0.1%
250.64	342	0.3%
249.957	431	0.3%
249.475	384	0.3%
249.413	397	0.3%
248.816	459	0.3%
247.847	567	0.4%
247.333	544	0.4%
246.57	594	0.4%
246.445	552	0.4%

Qdate
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	78
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

2003-04-01	5953
2002-10-01	5182
2003-07-01	4791
2003-01-01	4754
2001-10-01	3783
Other values (73)	110575

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2007-01-01
2nd row	2007-01-01
3rd row	2007-01-01
4th row	2007-01-01
5th row	2007-01-01

Common Values

Value	Count	Frequency (%)
2003-04-01	5953	4.4%
2002-10-01	5182	3.8%
2003-07-01	4791	3.5%
2003-01-01	4754	3.5%
2001-10-01	3783	2.8%
2002-07-01	3299	2.4%
2001-04-01	2922	2.2%
2009-04-01	2666	2.0%
2002-01-01	2577	1.9%
2012-10-01	2572	1.9%
Other values (68)	96539	71.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2003-04-01	5953	4.4%
2002-10-01	5182	3.8%
2003-07-01	4791	3.5%
2003-01-01	4754	3.5%
2001-10-01	3783	2.8%
2002-07-01	3299	2.4%
2001-04-01	2922	2.2%
2009-04-01	2666	2.0%
2002-01-01	2577	1.9%
2012-10-01	2572	1.9%
Other values (68)	96539	71.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

rGDP
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.083868244

Minimum	-8.4
Maximum	7.5
Zeros	0
Zeros (%)	0.0%
Negative	17017
Negative (%)	12.6%
Memory size	1.0 MiB

Quantile statistics

Minimum	-8.4
5-th percentile	-1.7
Q1	0.9
median	2.2
Q3	3.5
95-th percentile	5.5
Maximum	7.5
Range	15.9
Interquartile range (IQR)	2.6

Descriptive statistics

Standard deviation	2.31057909
Coefficient of variation (CV)	1.108793273
Kurtosis	3.309587534
Mean	2.083868244
Median Absolute Deviation (MAD)	1.3
Skewness	-0.8653541067
Sum	281401.4
Variance	5.338775732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
3.5	12026	8.9%
2.2	11496	8.5%
0.5	8479	6.3%
3.2	8333	6.2%
0.6	6134	4.5%
2	5702	4.2%
7	5245	3.9%
2.4	4933	3.7%
2.3	3969	2.9%
4.7	3902	2.9%
Other values (33)	64819	48.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-8.4	1073	0.8%
-4.4	2555	1.9%
-2.3	1452	1.1%
-2.1	1036	0.8%
-1.7	2388	1.8%
-1.1	3157	2.3%
-1	1218	0.9%
-0.6	2666	2.0%
-0.1	1472	1.1%
0.1	1404	1.0%

Value	Count	Frequency (%)
7.5	1072	0.8%
7	5245	3.9%
5.5	1211	0.9%
5.4	839	0.6%
5.3	33	< 0.1%
5	1351	1.0%
4.7	3902	2.9%
4.5	2402	1.8%
4.1	1245	0.9%
3.8	1224	0.9%

TCMR
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	233
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.478040072

Minimum	1.504
Maximum	6.661
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1.504
5-th percentile	1.719
Q1	2.324545455
median	3.675
Q3	4.347619048
95-th percentile	5.284
Maximum	6.661
Range	5.157
Interquartile range (IQR)	2.023073593

Descriptive statistics

Standard deviation	1.207100069
Coefficient of variation (CV)	0.3470633012
Kurtosis	-0.9648517968
Mean	3.478040072
Median Absolute Deviation (MAD)	1.0405
Skewness	0.1287623962
Sum	469667.5753
Variance	1.457090577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.975454545	2163	1.6%
3.958571429	2128	1.6%
3.334285714	1985	1.5%
3.569047619	1840	1.4%
4.032380952	1775	1.3%
3.940909091	1770	1.3%
3.807142857	1727	1.3%
4.048421053	1637	1.2%
4.445238095	1629	1.2%
5.0875	1582	1.2%
Other values (223)	116802	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.504	628	0.5%
1.526666667	788	0.6%
1.556521739	880	0.7%
1.622380952	771	0.6%
1.63047619	846	0.6%
1.644090909	662	0.5%
1.654	867	0.6%
1.67826087	891	0.7%
1.719	825	0.6%
1.723157895	767	0.6%

Value	Count	Frequency (%)
6.661	231	0.2%
6.5195	268	0.2%
6.440454545	370	0.3%
6.275454545	292	0.2%
6.256521739	332	0.2%
6.112	27	< 0.1%
6.097272727	410	0.3%
6.054	349	0.3%
6.034	135	0.1%
5.990526316	292	0.2%

POILWTIUSDM
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	233
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.27779559

Minimum	11.99
Maximum	133.9271429
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	11.99
5-th percentile	25.51
Q1	30.71
median	48.74863636
Q3	81.89952381
95-th percentile	103.2842857
Maximum	133.9271429
Range	121.9371429
Interquartile range (IQR)	51.18952381

Descriptive statistics

Standard deviation	27.84104655
Coefficient of variation (CV)	0.494707482
Kurtosis	-0.9150173174
Mean	56.27779559
Median Absolute Deviation (MAD)	20.34863636
Skewness	0.5551308717
Sum	7599640.961
Variance	775.123873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.73434783	2163	1.6%
28.32818182	2128	1.6%
30.71	1985	1.5%
28.20181818	1840	1.4%
29.44	1775	1.3%
28.85	1770	1.3%
33.31571429	1727	1.3%
26.56	1637	1.2%
31.58380952	1629	1.2%
32.91521739	1545	1.1%
Other values (223)	116839	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11.99	10	< 0.1%
12.34	10	< 0.1%
14.36	6	< 0.1%
17.23	6	< 0.1%
17.72	12	< 0.1%
17.75	6	< 0.1%
19.31	1281	0.9%
19.59	1318	1.0%
19.69	964	0.7%
19.89	7	< 0.1%

Value	Count	Frequency (%)
133.9271429	453	0.3%
133.8956522	358	0.3%
125.6554545	473	0.4%
116.6404762	361	0.3%
112.6186364	599	0.4%
110.0428571	308	0.2%
106.5463636	625	0.5%
106.3138095	460	0.3%
106.1504545	731	0.5%
105.3447619	476	0.4%

TTLCONS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	234
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	963119.3409

Minimum	708818
Maximum	1335425
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	708818
5-th percentile	798248
Q1	846777
median	891264
Q3	1101187
95-th percentile	1260760
Maximum	1335425
Range	626607
Interquartile range (IQR)	254410

Descriptive statistics

Standard deviation	153846.4496
Coefficient of variation (CV)	0.1597376805
Kurtosis	-0.7613237989
Mean	963119.3409
Median Absolute Deviation (MAD)	73530
Skewness	0.7804033785
Sum	1.300577096 × 10¹¹
Variance	2.366873004 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
891264	2163	1.6%
859459	2128	1.6%
880865	1985	1.5%
866814	1840	1.4%
855921	1775	1.3%
839690	1770	1.3%
851132	1727	1.3%
844697	1637	1.2%
901839	1629	1.2%
863855	1545	1.1%
Other values (224)	116839	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
708818	10	< 0.1%
726308	10	< 0.1%
727358	6	< 0.1%
728788	6	< 0.1%
737226	6	< 0.1%
739167	12	< 0.1%
741524	12	< 0.1%
745815	7	< 0.1%
751402	14	< 0.1%
755410	379	0.3%

Value	Count	Frequency (%)
1335425	384	0.3%
1333468	342	0.3%
1322364	431	0.3%
1317790	118	0.1%
1312855	397	0.3%
1297449	459	0.3%
1295930	567	0.4%
1290213	544	0.4%
1269670	387	0.3%
1268793	512	0.4%

DEXUSEU
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	234
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.180771125

Minimum	0.8525380952
Maximum	1.575863636
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0.8525380952
5-th percentile	0.8859954545
Q1	1.072657895
median	1.191335
Q3	1.316019048
95-th percentile	1.440286364
Maximum	1.575863636
Range	0.7233255411
Interquartile range (IQR)	0.2433611529

Descriptive statistics

Standard deviation	0.1727537297
Coefficient of variation (CV)	0.1463058556
Kurtosis	-0.7560880363
Mean	1.180771125
Median Absolute Deviation (MAD)	0.1222306522
Skewness	-0.15430538
Sum	159448.9711
Variance	0.02984385113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.136504545	2163	1.6%
1.086236364	2128	1.6%
1.167428571	1985	1.5%
1.155557143	1840	1.4%
1.019404762	1775	1.3%
0.98115	1770	1.3%
1.079742857	1727	1.3%
1.001289474	1637	1.2%
1.115519048	1629	1.2%
1.062247619	1545	1.1%
Other values (224)	116839	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.8525380952	442	0.3%
0.8529571429	941	0.7%
0.855152381	437	0.3%
0.8614857143	745	0.6%
0.869475	390	0.3%
0.8706947368	779	0.6%
0.8753136364	1040	0.8%
0.8766380952	834	0.6%
0.8831619048	964	0.7%
0.8859954545	687	0.5%

Value	Count	Frequency (%)
1.575863636	358	0.3%
1.575363636	599	0.4%
1.556171429	453	0.3%
1.555414286	473	0.4%
1.552019048	476	0.4%
1.495538095	361	0.3%
1.490752632	428	0.3%
1.482114286	444	0.3%
1.475945	572	0.4%
1.472814286	404	0.3%

BOPGSTB
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	231
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-42336.57545

Minimum	-67823
Maximum	-15946
Zeros	0
Zeros (%)	0.0%
Negative	135038
Negative (%)	100.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	-67823
5-th percentile	-61797
Q1	-45943
median	-41360
Q3	-36519
95-th percentile	-28800
Maximum	-15946
Range	51877
Interquartile range (IQR)	9424

Descriptive statistics

Standard deviation	9404.518716
Coefficient of variation (CV)	-0.2221369729
Kurtosis	0.1517299755
Mean	-42336.57545
Median Absolute Deviation (MAD)	4841
Skewness	-0.6459291409
Sum	-5717046476
Variance	88444972.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-41363	2163	1.6%
-41987	2128	1.6%
-39621	1985	1.5%
-40779	1840	1.4%
-43294	1775	1.3%
-35171	1770	1.3%
-43355	1727	1.3%
-39624	1637	1.2%
-39802	1629	1.2%
-37842	1608	1.2%
Other values (221)	116776	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-67823	332	0.2%
-67140	441	0.3%
-66842	358	0.3%
-66680	231	0.2%
-66525	301	0.2%
-64936	319	0.2%
-64923	456	0.3%
-64844	337	0.2%
-64366	286	0.2%
-64348	572	0.4%

Value	Count	Frequency (%)
-15946	10	< 0.1%
-17900	6	< 0.1%
-18254	6	< 0.1%
-18786	10	< 0.1%
-20229	6	< 0.1%
-22899	14	< 0.1%
-22977	12	< 0.1%
-23115	12	< 0.1%
-23421	7	< 0.1%
-23531	27	< 0.1%

GOLDAMGBD228NLBM
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	234
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	845.9498032

Minimum	256.1977273
Maximum	1780.647727
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	256.1977273
5-th percentile	272.0571429
Q1	350.7652174
median	857.7261905
Q3	1273.579545
95-th percentile	1671.886364
Maximum	1780.647727
Range	1524.45
Interquartile range (IQR)	922.8143281

Descriptive statistics

Standard deviation	498.1153598
Coefficient of variation (CV)	0.5888237788
Kurtosis	-1.438866177
Mean	845.9498032
Median Absolute Deviation (MAD)	479.702381
Skewness	0.2444715983
Sum	114235369.5
Variance	248118.9117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350.7652174	2163	1.6%
328.2075	2128	1.6%
356.9119048	1985	1.5%
355.405	1840	1.4%
333.3	1775	1.3%
316.7478261	1770	1.3%
341.5642857	1727	1.3%
319.2547619	1637	1.2%
358.9925	1629	1.2%
356.8636364	1545	1.1%
Other values (224)	116839	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
256.1977273	7	< 0.1%
256.9357143	12	< 0.1%
260.75	941	0.7%
261.4022727	12	< 0.1%
262.0175	759	0.6%
263.2727273	990	0.7%
264.4704545	14	< 0.1%
265.9340909	499	0.4%
265.9886364	437	0.3%
267.7068182	745	0.6%

Value	Count	Frequency (%)
1780.647727	664	0.5%
1759.5	454	0.3%
1746.347826	880	0.7%
1743.095238	669	0.5%
1741.925	767	0.6%
1735.977273	688	0.5%
1724.352273	867	0.6%
1687.342105	825	0.6%
1675.056818	731	0.5%
1671.886364	716	0.5%

CSUSHPISA
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	234
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	148.6342832

Minimum	93.236
Maximum	202.411
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	93.236
5-th percentile	111.111
Q1	130.151
median	145.632
Q3	169.868
95-th percentile	188.951
Maximum	202.411
Range	109.175
Interquartile range (IQR)	39.717

Descriptive statistics

Standard deviation	24.71270765
Coefficient of variation (CV)	0.1662651922
Kurtosis	-0.887312779
Mean	148.6342832
Median Absolute Deviation (MAD)	18.965
Skewness	0.1780414115
Sum	20071276.33
Variance	610.7179195
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
133.777	2163	1.6%
130.886	2128	1.6%
132.651	1985	1.5%
131.737	1840	1.4%
127.619	1775	1.3%
125.733	1770	1.3%
130.151	1727	1.3%
126.667	1637	1.2%
134.969	1629	1.2%
128.462	1545	1.1%
Other values (224)	116839	86.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
93.236	10	< 0.1%
93.698	10	< 0.1%
94.244	6	< 0.1%
94.813	6	< 0.1%
95.372	6	< 0.1%
96.003	12	< 0.1%
96.619	7	< 0.1%
97.246	12	< 0.1%
97.892	14	< 0.1%
98.554	27	< 0.1%

Value	Count	Frequency (%)
202.411	118	0.1%
201.758	342	0.3%
201.091	431	0.3%
200.347	397	0.3%
199.461	384	0.3%
198.472	459	0.3%
197.201	567	0.4%
196.012	544	0.4%
194.88	594	0.4%
193.794	552	0.4%

MSPUS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	76
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	231137.665

Minimum	157400
Maximum	337900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	157400
5-th percentile	171100
Q1	190100
median	224100
Q3	258400
95-th percentile	315600
Maximum	337900
Range	180500
Interquartile range (IQR)	68300

Descriptive statistics

Standard deviation	46186.08414
Coefficient of variation (CV)	0.1998206746
Kurtosis	-0.7330918917
Mean	231137.665
Median Absolute Deviation (MAD)	34000
Skewness	0.5377179553
Sum	3.1212368 × 10¹⁰
Variance	2133154368
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
191800	5953	4.4%
190100	5182	3.8%
191900	4791	3.5%
186000	4754	3.5%
171100	3783	2.8%
178100	3299	2.4%
238400	3286	2.4%
179000	2922	2.2%
220900	2666	2.0%
188700	2577	1.9%
Other values (66)	95825	71.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
157400	26	< 0.1%
158700	24	< 0.1%
159100	33	< 0.1%
163200	1072	0.8%
165300	1285	1.0%
168800	1142	0.8%
169800	2248	1.7%
171100	3783	2.8%
172500	2388	1.8%
172900	1322	1.0%

Value	Count	Frequency (%)
337900	1705	1.3%
331800	1240	0.9%
320500	1723	1.3%
318200	1685	1.2%
315600	891	0.7%
313100	1392	1.0%
310900	2100	1.6%
306000	1948	1.4%
303800	2354	1.7%
302500	1404	1.0%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Loan_Identifier	Origination_Channel	Seller_Name	Original_Interest_Rate	Original_UPB	Original_Loan_Term	Original_LTV_(OLTV)	Original_Combined_LTV_(CLTV)	Number_of_Borrowers	Original_Debt_to_Income_Ratio	Borrower_Credit_Score_at_Origination	Loan_purpose	Property_type	Number_of_units	Occupancy_type	Property_state	Zip_code_short	Primary_mortgage_insurance_percent	Product_type	Co-borrower_credit_score_at_origination	Mortgage_Insurance_type	Origination_Date	First_payment_date	First_time_home_buyer_indicator	UNRATE	CPIAUCSL	Qdate	rGDP	TCMR	POILWTIUSDM	TTLCONS	DEXUSEU	BOPGSTB	GOLDAMGBD228NLBM	CSUSHPISA	MSPUS
0	9.733730e+11	B	OTHER	6.875	32000.0	360.0	90.0	90.0	1.0	22.0	669.0	P	SF	1.0	P	AL	358.0	35.0	FRM	NaN	1.0	2007-02-01	2007-03-01	Y	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
1	9.276200e+11	B	PNC BANK, N.A.	5.875	200000.0	360.0	80.0	80.0	2.0	26.0	693.0	P	SF	1.0	P	AL	350.0	NaN	FRM	675.0	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
2	7.176670e+11	B	OTHER	6.250	122000.0	180.0	80.0	80.0	2.0	31.0	741.0	C	SF	1.0	P	AL	359.0	NaN	FRM	759.0	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
3	9.889510e+11	C	AMTRUST BANK	6.000	67000.0	180.0	77.0	77.0	2.0	17.0	804.0	C	SF	1.0	I	AL	356.0	NaN	FRM	805.0	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
4	1.908850e+11	R	OTHER	5.875	50000.0	180.0	41.0	41.0	2.0	10.0	658.0	C	SF	1.0	P	AR	728.0	NaN	FRM	697.0	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
5	7.533710e+11	R	OTHER	6.375	160000.0	360.0	95.0	95.0	3.0	28.0	665.0	P	SF	1.0	S	AR	719.0	30.0	FRM	NaN	1.0	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
6	7.038110e+11	C	CITIMORTGAGE, INC.	5.875	176000.0	180.0	80.0	90.0	2.0	22.0	773.0	C	SF	1.0	P	AR	721.0	NaN	FRM	NaN	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
7	7.947140e+11	B	FIRST TENNESSEE BANK NATIONAL ASSOCIATION	7.000	294000.0	360.0	80.0	80.0	2.0	28.0	783.0	P	PU	1.0	I	AZ	857.0	NaN	FRM	782.0	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
8	5.789070e+11	C	BANK OF AMERICA, N.A.	6.375	128000.0	360.0	66.0	66.0	1.0	41.0	668.0	C	SF	1.0	P	AZ	850.0	NaN	FRM	NaN	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0
9	8.264440e+11	C	BANK OF AMERICA, N.A.	6.375	115000.0	360.0	35.0	35.0	2.0	20.0	792.0	C	SF	1.0	P	AZ	856.0	NaN	FRM	704.0	NaN	2007-02-01	2007-04-01	N	4.5	204.226	2007-01-01	0.9	4.722632	59.257	1138752.0	1.308021	-58478.0	665.1025	184.601	257400.0

Last rows

	Loan_Identifier	Origination_Channel	Seller_Name	Original_Interest_Rate	Original_UPB	Original_Loan_Term	Original_LTV_(OLTV)	Original_Combined_LTV_(CLTV)	Number_of_Borrowers	Original_Debt_to_Income_Ratio	Borrower_Credit_Score_at_Origination	Loan_purpose	Property_type	Number_of_units	Occupancy_type	Property_state	Zip_code_short	Primary_mortgage_insurance_percent	Product_type	Co-borrower_credit_score_at_origination	Mortgage_Insurance_type	Origination_Date	First_payment_date	First_time_home_buyer_indicator	UNRATE	CPIAUCSL	Qdate	rGDP	TCMR	POILWTIUSDM	TTLCONS	DEXUSEU	BOPGSTB	GOLDAMGBD228NLBM	CSUSHPISA	MSPUS
135028	3.093700e+11	R	LOANDEPOT.COM, LLC	4.875	240000.0	360.0	60.0	60.0	1.0	47.0	711.0	C	PU	1.0	P	VA	201.0	NaN	FRM	NaN	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135029	7.464840e+11	R	OTHER	4.625	415000.0	360.0	58.0	58.0	2.0	27.0	799.0	P	SF	1.0	P	VA	222.0	NaN	FRM	786.0	NaN	2018-06-01	2018-08-01	Y	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135030	9.961980e+11	R	OTHER	4.625	118000.0	180.0	67.0	67.0	1.0	28.0	802.0	P	CO	1.0	S	VT	57.0	NaN	FRM	NaN	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135031	1.149900e+11	R	OTHER	4.875	344000.0	360.0	97.0	97.0	2.0	42.0	711.0	P	CO	1.0	P	WA	982.0	25.0	FRM	729.0	1.0	2018-06-01	2018-08-01	Y	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135032	9.415520e+11	R	FAIRWAY INDEPENDENT MORTGAGE CORPORATION	4.990	364000.0	360.0	80.0	80.0	1.0	45.0	785.0	P	SF	1.0	P	WA	985.0	NaN	FRM	NaN	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135033	9.204900e+11	R	OTHER	4.625	200000.0	240.0	50.0	50.0	1.0	45.0	717.0	R	PU	1.0	P	WA	986.0	NaN	FRM	NaN	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135034	9.666890e+11	R	OTHER	4.625	94000.0	360.0	47.0	47.0	1.0	39.0	677.0	R	SF	1.0	P	WI	531.0	NaN	FRM	NaN	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135035	6.616280e+11	R	OTHER	4.625	239000.0	360.0	74.0	74.0	2.0	20.0	788.0	R	SF	1.0	S	WI	545.0	NaN	FRM	739.0	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135036	5.102850e+11	R	OTHER	5.000	93000.0	360.0	44.0	44.0	1.0	19.0	621.0	C	SF	1.0	P	WI	537.0	NaN	FRM	NaN	NaN	2018-06-01	2018-08-01	N	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0
135037	4.330130e+11	R	OTHER	5.125	140000.0	360.0	94.0	94.0	1.0	36.0	660.0	P	SF	1.0	P	WI	549.0	30.0	FRM	NaN	1.0	2018-06-01	2018-08-01	Y	4.0	251.176	2018-04-01	3.5	2.89	67.522857	1317790.0	1.1679	-47431.0	1299.15	202.411	315600.0

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block